#!/bin/bash

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap\
--table rpt_date_line_clue_ct \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_date_line_clue_ct \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap\
--table rpt_date_area_line_clue_ct \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_date_area_line_clue_ct \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap\
--table rpt_date_subject_line_clue_ct \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_date_subject_line_clue_ct \
-m 1



sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap\
--table rpt_date_school_line_clue_ct \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_date_school_line_clue_ct \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap\
--table rpt_date_oc_line_clue_ct \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_date_oc_line_clue_ct \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap\
--table rpt_date_dp_line_clue_ct \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_date_dp_line_clue_ct \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap\
--table rpt_day_line_clue_valid \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_day_line_clue_valid \
-m 1


sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap\
--table rpt_day_line_clue_valid_percent \
--input-fields-terminated-by '\t' \
--hcatalog-database oe_rpt \
--hcatalog-table rpt_day_line_clue_valid_percent \
-m 1